Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 20030 |
| Missing cells | 24884 |
| Missing cells (%) | 7.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.4 MiB |
| Average record size in memory | 128.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 5 |
| Unsupported | 1 |
name has a high cardinality: 19503 distinct values | High cardinality |
host_name has a high cardinality: 5915 distinct values | High cardinality |
last_review has a high cardinality: 1202 distinct values | High cardinality |
latitude is highly overall correlated with neighbourhood | High correlation |
longitude is highly overall correlated with neighbourhood | High correlation |
number_of_reviews is highly overall correlated with reviews_per_month | High correlation |
reviews_per_month is highly overall correlated with number_of_reviews | High correlation |
neighbourhood is highly overall correlated with latitude and 1 other fields | High correlation |
room_type is highly imbalanced (52.1%) | Imbalance |
neighbourhood_group has 20030 (100.0%) missing values | Missing |
last_review has 2406 (12.0%) missing values | Missing |
reviews_per_month has 2406 (12.0%) missing values | Missing |
price is highly skewed (γ1 = 25.44770219) | Skewed |
minimum_nights is highly skewed (γ1 = 56.36139206) | Skewed |
name is uniformly distributed | Uniform |
id has unique values | Unique |
latitude has unique values | Unique |
longitude has unique values | Unique |
neighbourhood_group is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
number_of_reviews has 2388 (11.9%) zeros | Zeros |
availability_365 has 9344 (46.7%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-04 20:41:57.041415 |
|---|---|
| Analysis finished | 2023-05-04 20:42:16.129619 |
| Duration | 19.09 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
id
Real number (ℝ)
| Distinct | 20030 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15417254 |
| Minimum | 2818 |
|---|---|
| Maximum | 30580413 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 156.6 KiB |
Quantile statistics
| Minimum | 2818 |
|---|---|
| 5-th percentile | 1355640.1 |
| Q1 | 8188422.8 |
| median | 15630490 |
| Q3 | 22025770 |
| 95-th percentile | 29148116 |
| Maximum | 30580413 |
| Range | 30577595 |
| Interquartile range (IQR) | 13837348 |
Descriptive statistics
| Standard deviation | 8569403.6 |
|---|---|
| Coefficient of variation (CV) | 0.55583203 |
| Kurtosis | -1.0603338 |
| Mean | 15417254 |
| Median Absolute Deviation (MAD) | 6836429 |
| Skewness | -0.049708236 |
| Sum | 3.088076 × 1011 |
| Variance | 7.3434678 × 1013 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 2818 | 1 | < 0.1% |
| 19981710 | 1 | < 0.1% |
| 19989602 | 1 | < 0.1% |
| 19988595 | 1 | < 0.1% |
| 19987998 | 1 | < 0.1% |
| 19984655 | 1 | < 0.1% |
| 19984496 | 1 | < 0.1% |
| 19983345 | 1 | < 0.1% |
| 19982520 | 1 | < 0.1% |
| 19980693 | 1 | < 0.1% |
| Other values (20020) | 20020 |
| Value | Count | Frequency (%) |
| 2818 | 1 | |
| 3209 | 1 | |
| 20168 | 1 | |
| 25428 | 1 | |
| 27886 | 1 | |
| 28658 | 1 | |
| 28871 | 1 | |
| 29051 | 1 | |
| 31080 | 1 | |
| 41125 | 1 |
| Value | Count | Frequency (%) |
| 30580413 | 1 | |
| 30579673 | 1 | |
| 30578037 | 1 | |
| 30577727 | 1 | |
| 30576148 | 1 | |
| 30573892 | 1 | |
| 30563877 | 1 | |
| 30562689 | 1 | |
| 30562273 | 1 | |
| 30561688 | 1 |
name
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 19503 |
|---|---|
| Distinct (%) | 97.6% |
| Missing | 38 |
| Missing (%) | 0.2% |
| Memory size | 156.6 KiB |
| Amsterdam | 39 |
|---|---|
| Amsterdam Appartement | 11 |
| Lovely apartment near Vondelpark | 8 |
| Apartment in Amsterdam | 7 |
| Spacious apartment with garden | 6 |
| Other values (19498) |
Length
| Max length | 122 |
|---|---|
| Median length | 86 |
| Mean length | 37.887855 |
| Min length | 1 |
Characters and Unicode
| Total characters | 757454 |
|---|---|
| Distinct characters | 182 |
| Distinct categories | 20 ? |
| Distinct scripts | 7 ? |
| Distinct blocks | 14 ? |
Unique
| Unique | 19174 ? |
|---|---|
| Unique (%) | 95.9% |
Sample
| 1st row | Quiet Garden View Room & Super Fast WiFi |
|---|---|
| 2nd row | Quiet apt near center, great view |
| 3rd row | 100%Centre-Studio 1 Private Floor/Bathroom |
| 4th row | Lovely apt in City Centre (Jordaan) |
| 5th row | Romantic, stylish B&B houseboat in canal district |
Common Values
| Value | Count | Frequency (%) |
| Amsterdam | 39 | 0.2% |
| Amsterdam Appartement | 11 | 0.1% |
| Lovely apartment near Vondelpark | 8 | < 0.1% |
| Apartment in Amsterdam | 7 | < 0.1% |
| Spacious apartment with garden | 6 | < 0.1% |
| Beautiful apartment in Amsterdam | 6 | < 0.1% |
| Beautiful apartment near Vondelpark | 6 | < 0.1% |
| Amsterdam Apartment | 6 | < 0.1% |
| Spacious apartment in Amsterdam | 6 | < 0.1% |
| Cosy apartment in Amsterdam West | 5 | < 0.1% |
| Other values (19493) | 19892 | |
| (Missing) | 38 | 0.2% |
Length
| Value | Count | Frequency (%) |
| apartment | 7792 | 6.5% |
| in | 6599 | 5.5% |
| amsterdam | 4527 | 3.8% |
| 3924 | 3.3% | |
| with | 2991 | 2.5% |
| the | 2436 | 2.0% |
| spacious | 2293 | 1.9% |
| city | 2068 | 1.7% |
| room | 1890 | 1.6% |
| centre | 1860 | 1.6% |
| Other values (5172) | 82662 |
Most occurring characters
| Value | Count | Frequency (%) |
| 99532 | 13.1% | |
| e | 65900 | 8.7% |
| t | 61721 | 8.1% |
| a | 58168 | 7.7% |
| r | 48161 | 6.4% |
| n | 43803 | 5.8% |
| o | 40023 | 5.3% |
| i | 36552 | 4.8% |
| m | 30294 | 4.0% |
| s | 24205 | 3.2% |
| Other values (172) | 249095 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 570345 | |
| Space Separator | 99536 | 13.1% |
| Uppercase Letter | 64139 | 8.5% |
| Other Punctuation | 11726 | 1.5% |
| Decimal Number | 6389 | 0.8% |
| Dash Punctuation | 1905 | 0.3% |
| Math Symbol | 1509 | 0.2% |
| Close Punctuation | 760 | 0.1% |
| Open Punctuation | 733 | 0.1% |
| Other Symbol | 224 | < 0.1% |
| Other values (10) | 188 | < 0.1% |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| ム | 2 | 4.7% |
| 到 | 2 | 4.7% |
| 年 | 2 | 4.7% |
| 交 | 1 | 2.3% |
| 公 | 1 | 2.3% |
| 坐 | 1 | 2.3% |
| 中 | 1 | 2.3% |
| 北 | 1 | 2.3% |
| 心 | 1 | 2.3% |
| 站 | 1 | 2.3% |
| Other values (30) | 30 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 65900 | |
| t | 61721 | |
| a | 58168 | |
| r | 48161 | 8.4% |
| n | 43803 | 7.7% |
| o | 40023 | 7.0% |
| i | 36552 | 6.4% |
| m | 30294 | 5.3% |
| s | 24205 | 4.2% |
| p | 21598 | 3.8% |
| Other values (23) | 139920 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 10601 | |
| C | 7461 | 11.6% |
| S | 5049 | 7.9% |
| B | 3724 | 5.8% |
| L | 3705 | 5.8% |
| R | 3353 | 5.2% |
| P | 3222 | 5.0% |
| E | 2943 | 4.6% |
| T | 2695 | 4.2% |
| N | 2596 | 4.0% |
| Other values (19) | 18790 |
Other Symbol
| Value | Count | Frequency (%) |
| ★ | 152 | |
| ☆ | 24 | 10.7% |
| ❤ | 18 | 8.0% |
| ♥ | 7 | 3.1% |
| ☘ | 4 | 1.8% |
| ● | 3 | 1.3% |
| ✿ | 2 | 0.9% |
| ° | 2 | 0.9% |
| ⏹ | 2 | 0.9% |
| ☟ | 1 | 0.4% |
| Other values (9) | 9 | 4.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 3059 | |
| ! | 2581 | |
| & | 2003 | |
| . | 1442 | |
| ' | 878 | 7.5% |
| / | 658 | 5.6% |
| @ | 370 | 3.2% |
| " | 274 | 2.3% |
| : | 214 | 1.8% |
| * | 143 | 1.2% |
| Other values (7) | 104 | 0.9% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 2227 | |
| 1 | 1146 | |
| 0 | 877 | 13.7% |
| 5 | 551 | 8.6% |
| 3 | 491 | 7.7% |
| 4 | 465 | 7.3% |
| 9 | 170 | 2.7% |
| 8 | 155 | 2.4% |
| 7 | 154 | 2.4% |
| 6 | 153 | 2.4% |
Math Symbol
| Value | Count | Frequency (%) |
| | | 802 | |
| + | 677 | |
| ~ | 10 | 0.7% |
| < | 9 | 0.6% |
| = | 4 | 0.3% |
| > | 3 | 0.2% |
| ± | 2 | 0.1% |
| → | 1 | 0.1% |
| ≠ | 1 | 0.1% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 752 | |
| ] | 7 | 0.9% |
| 】 | 1 | 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 725 | |
| [ | 7 | 1.0% |
| 【 | 1 | 0.1% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 3 | |
| ˜ | 3 | |
| ´ | 2 |
Space Separator
| Value | Count | Frequency (%) |
| 99532 | ||
| 4 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1900 | |
| – | 5 | 0.3% |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 44 | |
| ” | 7 | 13.7% |
Nonspacing Mark
| Value | Count | Frequency (%) |
| ️ | 18 | |
| ︎ | 1 | 5.3% |
Initial Punctuation
| Value | Count | Frequency (%) |
| ‘ | 13 | |
| “ | 7 |
Currency Symbol
| Value | Count | Frequency (%) |
| € | 1 | |
| $ | 1 |
Other Number
| Value | Count | Frequency (%) |
| ² | 22 |
Control
| Value | Count | Frequency (%) |
| 18 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 4 |
Modifier Letter
| Value | Count | Frequency (%) |
| ゙ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 634482 | |
| Common | 122908 | 16.2% |
| Han | 34 | < 0.1% |
| Inherited | 19 | < 0.1% |
| Katakana | 7 | < 0.1% |
| Cyrillic | 2 | < 0.1% |
| Hiragana | 2 | < 0.1% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 99532 | ||
| , | 3059 | 2.5% |
| ! | 2581 | 2.1% |
| 2 | 2227 | 1.8% |
| & | 2003 | 1.6% |
| - | 1900 | 1.5% |
| . | 1442 | 1.2% |
| 1 | 1146 | 0.9% |
| ' | 878 | 0.7% |
| 0 | 877 | 0.7% |
| Other values (68) | 7263 | 5.9% |
Latin
| Value | Count | Frequency (%) |
| e | 65900 | 10.4% |
| t | 61721 | 9.7% |
| a | 58168 | 9.2% |
| r | 48161 | 7.6% |
| n | 43803 | 6.9% |
| o | 40023 | 6.3% |
| i | 36552 | 5.8% |
| m | 30294 | 4.8% |
| s | 24205 | 3.8% |
| p | 21598 | 3.4% |
| Other values (50) | 204057 |
Han
| Value | Count | Frequency (%) |
| 到 | 2 | 5.9% |
| 年 | 2 | 5.9% |
| 交 | 1 | 2.9% |
| 公 | 1 | 2.9% |
| 坐 | 1 | 2.9% |
| 中 | 1 | 2.9% |
| 北 | 1 | 2.9% |
| 心 | 1 | 2.9% |
| 站 | 1 | 2.9% |
| 丹 | 1 | 2.9% |
| Other values (22) | 22 |
Katakana
| Value | Count | Frequency (%) |
| ム | 2 | |
| ア | 1 | |
| ス | 1 | |
| テ | 1 | |
| ル | 1 | |
| タ | 1 |
Inherited
| Value | Count | Frequency (%) |
| ️ | 18 | |
| ︎ | 1 | 5.3% |
Cyrillic
| Value | Count | Frequency (%) |
| м | 1 | |
| А | 1 |
Hiragana
| Value | Count | Frequency (%) |
| を | 1 | |
| で | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 756980 | |
| Misc Symbols | 191 | < 0.1% |
| Punctuation | 99 | < 0.1% |
| None | 92 | < 0.1% |
| CJK | 34 | < 0.1% |
| Dingbats | 24 | < 0.1% |
| VS | 19 | < 0.1% |
| Modifier Letters | 3 | < 0.1% |
| Geometric Shapes | 3 | < 0.1% |
| Misc Technical | 3 | < 0.1% |
| Other values (4) | 6 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 99532 | ||
| e | 65900 | 8.7% |
| t | 61721 | 8.2% |
| a | 58168 | 7.7% |
| r | 48161 | 6.4% |
| n | 43803 | 5.8% |
| o | 40023 | 5.3% |
| i | 36552 | 4.8% |
| m | 30294 | 4.0% |
| s | 24205 | 3.2% |
| Other values (82) | 248621 |
Misc Symbols
| Value | Count | Frequency (%) |
| ★ | 152 | |
| ☆ | 24 | 12.6% |
| ♥ | 7 | 3.7% |
| ☘ | 4 | 2.1% |
| ☟ | 1 | 0.5% |
| ☼ | 1 | 0.5% |
| ♛ | 1 | 0.5% |
| ♡ | 1 | 0.5% |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 44 | |
| • | 23 | |
| ‘ | 13 | 13.1% |
| “ | 7 | 7.1% |
| ” | 7 | 7.1% |
| – | 5 | 5.1% |
None
| Value | Count | Frequency (%) |
| é | 27 | |
| ² | 22 | |
| É | 4 | 4.3% |
| 4 | 4.3% | |
| · | 4 | 4.3% |
| à | 3 | 3.3% |
| ム | 2 | 2.2% |
| ° | 2 | 2.2% |
| ü | 2 | 2.2% |
| ´ | 2 | 2.2% |
| Other values (16) | 20 |
VS
| Value | Count | Frequency (%) |
| ️ | 18 | |
| ︎ | 1 | 5.3% |
Dingbats
| Value | Count | Frequency (%) |
| ❤ | 18 | |
| ✿ | 2 | 8.3% |
| ✭ | 1 | 4.2% |
| ✓ | 1 | 4.2% |
| ❣ | 1 | 4.2% |
| ✯ | 1 | 4.2% |
Modifier Letters
| Value | Count | Frequency (%) |
| ˜ | 3 |
Geometric Shapes
| Value | Count | Frequency (%) |
| ● | 3 |
CJK
| Value | Count | Frequency (%) |
| 到 | 2 | 5.9% |
| 年 | 2 | 5.9% |
| 交 | 1 | 2.9% |
| 公 | 1 | 2.9% |
| 坐 | 1 | 2.9% |
| 中 | 1 | 2.9% |
| 北 | 1 | 2.9% |
| 心 | 1 | 2.9% |
| 站 | 1 | 2.9% |
| 丹 | 1 | 2.9% |
| Other values (22) | 22 |
Misc Technical
| Value | Count | Frequency (%) |
| ⏹ | 2 | |
| ⏺ | 1 |
Cyrillic
| Value | Count | Frequency (%) |
| м | 1 | |
| А | 1 |
Hiragana
| Value | Count | Frequency (%) |
| を | 1 | |
| で | 1 |
Math Operators
| Value | Count | Frequency (%) |
| ≠ | 1 |
Currency Symbols
| Value | Count | Frequency (%) |
| € | 1 |
host_id
Real number (ℝ)
| Distinct | 17264 |
|---|---|
| Distinct (%) | 86.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48685695 |
| Minimum | 3159 |
|---|---|
| Maximum | 2.2936124 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 156.6 KiB |
Quantile statistics
| Minimum | 3159 |
|---|---|
| 5-th percentile | 1725242 |
| Q1 | 8093515.8 |
| median | 23694499 |
| Q3 | 68275352 |
| 95-th percentile | 1.8463359 × 108 |
| Maximum | 2.2936124 × 108 |
| Range | 2.2935808 × 108 |
| Interquartile range (IQR) | 60181836 |
Descriptive statistics
| Standard deviation | 56496353 |
|---|---|
| Coefficient of variation (CV) | 1.1604302 |
| Kurtosis | 1.4522264 |
| Mean | 48685695 |
| Median Absolute Deviation (MAD) | 19349992 |
| Skewness | 1.5226291 |
| Sum | 9.7517448 × 1011 |
| Variance | 3.1918379 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 65859990 | 208 | 1.0% |
| 1464510 | 105 | 0.5% |
| 76104209 | 83 | 0.4% |
| 113977564 | 38 | 0.2% |
| 517215 | 30 | 0.1% |
| 107745142 | 27 | 0.1% |
| 14183886 | 25 | 0.1% |
| 11969034 | 24 | 0.1% |
| 44168250 | 21 | 0.1% |
| 7594884 | 21 | 0.1% |
| Other values (17254) | 19448 |
| Value | Count | Frequency (%) |
| 3159 | 1 | |
| 3806 | 1 | |
| 5988 | 1 | |
| 12085 | 1 | |
| 20405 | 1 | |
| 30390 | 1 | |
| 34080 | 1 | |
| 36701 | 1 | |
| 47517 | 1 | |
| 49851 | 1 |
| Value | Count | Frequency (%) |
| 229361236 | 1 | < 0.1% |
| 229295710 | 1 | < 0.1% |
| 229260989 | 1 | < 0.1% |
| 229196646 | 5 | |
| 229109698 | 1 | < 0.1% |
| 229053056 | 4 | |
| 229026227 | 1 | < 0.1% |
| 229023758 | 1 | < 0.1% |
| 228892275 | 1 | < 0.1% |
| 228856945 | 1 | < 0.1% |
host_name
Categorical
| Distinct | 5915 |
|---|---|
| Distinct (%) | 29.5% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Memory size | 156.6 KiB |
| Martijn | 289 |
|---|---|
| Michiel And Jane | 105 |
| Laura | 98 |
| Anne | 90 |
| Marieke | 88 |
| Other values (5910) |
Length
| Max length | 34 |
|---|---|
| Median length | 30 |
| Mean length | 6.2987616 |
| Min length | 1 |
Characters and Unicode
| Total characters | 126139 |
|---|---|
| Distinct characters | 103 |
| Distinct categories | 13 ? |
| Distinct scripts | 4 ? |
| Distinct blocks | 5 ? |
Unique
| Unique | 3662 ? |
|---|---|
| Unique (%) | 18.3% |
Sample
| 1st row | Daniel |
|---|---|
| 2nd row | Maartje |
| 3rd row | Alex |
| 4th row | Joan |
| 5th row | Flip |
Common Values
| Value | Count | Frequency (%) |
| Martijn | 289 | 1.4% |
| Michiel And Jane | 105 | 0.5% |
| Laura | 98 | 0.5% |
| Anne | 90 | 0.4% |
| Marieke | 88 | 0.4% |
| Eva | 88 | 0.4% |
| Willem | 87 | 0.4% |
| Rated | 83 | 0.4% |
| Thomas | 80 | 0.4% |
| David | 77 | 0.4% |
| Other values (5905) | 18941 |
Length
| Value | Count | Frequency (%) |
| 715 | 3.1% | |
| martijn | 296 | 1.3% |
| and | 234 | 1.0% |
| michiel | 183 | 0.8% |
| en | 137 | 0.6% |
| jan | 125 | 0.5% |
| jane | 110 | 0.5% |
| laura | 109 | 0.5% |
| willem | 105 | 0.5% |
| anne | 104 | 0.5% |
| Other values (5299) | 20786 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 14096 | 11.2% |
| e | 14076 | 11.2% |
| i | 10788 | 8.6% |
| n | 10549 | 8.4% |
| r | 8367 | 6.6% |
| l | 5733 | 4.5% |
| o | 5579 | 4.4% |
| t | 4821 | 3.8% |
| s | 4089 | 3.2% |
| M | 3150 | 2.5% |
| Other values (93) | 44891 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 99519 | |
| Uppercase Letter | 22532 | 17.9% |
| Space Separator | 2888 | 2.3% |
| Other Punctuation | 913 | 0.7% |
| Dash Punctuation | 155 | 0.1% |
| Open Punctuation | 50 | < 0.1% |
| Close Punctuation | 50 | < 0.1% |
| Decimal Number | 12 | < 0.1% |
| Math Symbol | 10 | < 0.1% |
| Other Symbol | 6 | < 0.1% |
| Other values (3) | 4 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 14096 | |
| e | 14076 | |
| i | 10788 | |
| n | 10549 | |
| r | 8367 | |
| l | 5733 | 5.8% |
| o | 5579 | 5.6% |
| t | 4821 | 4.8% |
| s | 4089 | 4.1% |
| u | 2569 | 2.6% |
| Other values (42) | 18852 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 3150 | |
| J | 2136 | 9.5% |
| A | 1893 | 8.4% |
| S | 1752 | 7.8% |
| R | 1429 | 6.3% |
| E | 1263 | 5.6% |
| L | 1253 | 5.6% |
| C | 952 | 4.2% |
| D | 949 | 4.2% |
| B | 888 | 3.9% |
| Other values (20) | 6867 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 768 | |
| . | 95 | 10.4% |
| , | 35 | 3.8% |
| ' | 8 | 0.9% |
| / | 6 | 0.7% |
| @ | 1 | 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 6 | |
| 5 | 2 | 16.7% |
| 3 | 2 | 16.7% |
| 2 | 1 | 8.3% |
| 9 | 1 | 8.3% |
Other Letter
| Value | Count | Frequency (%) |
| 雨 | 1 | |
| 婷 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 2888 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 155 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 50 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 50 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 10 |
Other Symbol
| Value | Count | Frequency (%) |
| ★ | 6 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ´ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 122045 | |
| Common | 4086 | 3.2% |
| Cyrillic | 6 | < 0.1% |
| Han | 2 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 14096 | 11.5% |
| e | 14076 | 11.5% |
| i | 10788 | 8.8% |
| n | 10549 | 8.6% |
| r | 8367 | 6.9% |
| l | 5733 | 4.7% |
| o | 5579 | 4.6% |
| t | 4821 | 4.0% |
| s | 4089 | 3.4% |
| M | 3150 | 2.6% |
| Other values (67) | 40797 |
Common
| Value | Count | Frequency (%) |
| 2888 | ||
| & | 768 | 18.8% |
| - | 155 | 3.8% |
| . | 95 | 2.3% |
| ( | 50 | 1.2% |
| ) | 50 | 1.2% |
| , | 35 | 0.9% |
| + | 10 | 0.2% |
| ' | 8 | 0.2% |
| ★ | 6 | 0.1% |
| Other values (9) | 21 | 0.5% |
Cyrillic
| Value | Count | Frequency (%) |
| а | 2 | |
| с | 1 | |
| О | 1 | |
| к | 1 | |
| н | 1 |
Han
| Value | Count | Frequency (%) |
| 雨 | 1 | |
| 婷 | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 125923 | |
| None | 202 | 0.2% |
| Misc Symbols | 6 | < 0.1% |
| Cyrillic | 6 | < 0.1% |
| CJK | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 14096 | 11.2% |
| e | 14076 | 11.2% |
| i | 10788 | 8.6% |
| n | 10549 | 8.4% |
| r | 8367 | 6.6% |
| l | 5733 | 4.6% |
| o | 5579 | 4.4% |
| t | 4821 | 3.8% |
| s | 4089 | 3.2% |
| M | 3150 | 2.5% |
| Other values (59) | 44675 |
None
| Value | Count | Frequency (%) |
| é | 83 | |
| ë | 34 | |
| è | 19 | 9.4% |
| í | 10 | 5.0% |
| ç | 8 | 4.0% |
| ï | 8 | 4.0% |
| á | 7 | 3.5% |
| ö | 4 | 2.0% |
| ü | 4 | 2.0% |
| ı | 3 | 1.5% |
| Other values (16) | 22 | 10.9% |
Misc Symbols
| Value | Count | Frequency (%) |
| ★ | 6 |
Cyrillic
| Value | Count | Frequency (%) |
| а | 2 | |
| с | 1 | |
| О | 1 | |
| к | 1 | |
| н | 1 |
CJK
| Value | Count | Frequency (%) |
| 雨 | 1 | |
| 婷 | 1 |
neighbourhood_group
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 20030 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 156.6 KiB |
neighbourhood
Categorical
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.6 KiB |
| De Baarsjes - Oud-West | |
|---|---|
| De Pijp - Rivierenbuurt | |
| Centrum-West | |
| Centrum-Oost | |
| Westerpark | |
| Other values (17) |
Length
| Max length | 38 |
|---|---|
| Median length | 23 |
| Mean length | 15.978283 |
| Min length | 4 |
Characters and Unicode
| Total characters | 320045 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Oostelijk Havengebied - Indische Buurt |
|---|---|
| 2nd row | Westerpark |
| 3rd row | Centrum-Oost |
| 4th row | Centrum-West |
| 5th row | Centrum-West |
Common Values
| Value | Count | Frequency (%) |
| De Baarsjes - Oud-West | 3515 | |
| De Pijp - Rivierenbuurt | 2493 | |
| Centrum-West | 2326 | |
| Centrum-Oost | 1730 | |
| Westerpark | 1490 | |
| Zuid | 1441 | |
| Oud-Oost | 1282 | 6.4% |
| Bos en Lommer | 1145 | 5.7% |
| Oostelijk Havengebied - Indische Buurt | 959 | 4.8% |
| Oud-Noord | 571 | 2.9% |
| Other values (12) | 3078 |
Length
| Value | Count | Frequency (%) |
| 8157 | ||
| de | 6150 | |
| baarsjes | 3515 | 7.5% |
| oud-west | 3515 | 7.5% |
| pijp | 2493 | 5.3% |
| rivierenbuurt | 2493 | 5.3% |
| centrum-west | 2326 | 5.0% |
| centrum-oost | 1730 | 3.7% |
| westerpark | 1490 | 3.2% |
| zuid | 1441 | 3.1% |
| Other values (27) | 13534 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 41836 | 13.1% |
| 26814 | 8.4% | |
| r | 24136 | 7.5% |
| s | 22204 | 6.9% |
| t | 21810 | 6.8% |
| u | 19662 | 6.1% |
| - | 18365 | 5.7% |
| i | 13244 | 4.1% |
| a | 13001 | 4.1% |
| d | 11466 | 3.6% |
| Other values (31) | 107507 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 226664 | |
| Uppercase Letter | 48202 | 15.1% |
| Space Separator | 26814 | 8.4% |
| Dash Punctuation | 18365 | 5.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 41836 | |
| r | 24136 | |
| s | 22204 | |
| t | 21810 | |
| u | 19662 | |
| i | 13244 | 5.8% |
| a | 13001 | 5.7% |
| d | 11466 | 5.1% |
| n | 10913 | 4.8% |
| o | 9938 | 4.4% |
| Other values (13) | 38454 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 9851 | |
| W | 8203 | |
| D | 6272 | |
| B | 6088 | |
| C | 4167 | |
| P | 2493 | 5.2% |
| R | 2493 | 5.2% |
| Z | 2155 | 4.5% |
| I | 1411 | 2.9% |
| N | 1290 | 2.7% |
| Other values (6) | 3779 | 7.8% |
Space Separator
| Value | Count | Frequency (%) |
| 26814 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 18365 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 274866 | |
| Common | 45179 | 14.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 41836 | |
| r | 24136 | 8.8% |
| s | 22204 | 8.1% |
| t | 21810 | 7.9% |
| u | 19662 | 7.2% |
| i | 13244 | 4.8% |
| a | 13001 | 4.7% |
| d | 11466 | 4.2% |
| n | 10913 | 4.0% |
| o | 9938 | 3.6% |
| Other values (29) | 86656 |
Common
| Value | Count | Frequency (%) |
| 26814 | ||
| - | 18365 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 320045 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 41836 | 13.1% |
| 26814 | 8.4% | |
| r | 24136 | 7.5% |
| s | 22204 | 6.9% |
| t | 21810 | 6.8% |
| u | 19662 | 6.1% |
| - | 18365 | 5.7% |
| i | 13244 | 4.1% |
| a | 13001 | 4.1% |
| d | 11466 | 3.6% |
| Other values (31) | 107507 |
latitude
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 20030 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52.365212 |
| Minimum | 52.288378 |
|---|---|
| Maximum | 52.424713 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 156.6 KiB |
Quantile statistics
| Minimum | 52.288378 |
|---|---|
| 5-th percentile | 52.342687 |
| Q1 | 52.355126 |
| median | 52.36459 |
| Q3 | 52.375074 |
| 95-th percentile | 52.39005 |
| Maximum | 52.424713 |
| Range | 0.13633432 |
| Interquartile range (IQR) | 0.019948024 |
Descriptive statistics
| Standard deviation | 0.015995991 |
|---|---|
| Coefficient of variation (CV) | 0.0003054698 |
| Kurtosis | 2.1181302 |
| Mean | 52.365212 |
| Median Absolute Deviation (MAD) | 0.0098915095 |
| Skewness | -0.1977422 |
| Sum | 1048875.2 |
| Variance | 0.00025587173 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 52.36575451 | 1 | < 0.1% |
| 52.37934236 | 1 | < 0.1% |
| 52.34363541 | 1 | < 0.1% |
| 52.37879082 | 1 | < 0.1% |
| 52.35459348 | 1 | < 0.1% |
| 52.38561195 | 1 | < 0.1% |
| 52.37284509 | 1 | < 0.1% |
| 52.36991662 | 1 | < 0.1% |
| 52.35877933 | 1 | < 0.1% |
| 52.3961998 | 1 | < 0.1% |
| Other values (20020) | 20020 |
| Value | Count | Frequency (%) |
| 52.28837824 | 1 | |
| 52.28927442 | 1 | |
| 52.29030764 | 1 | |
| 52.29068744 | 1 | |
| 52.29109538 | 1 | |
| 52.29164386 | 1 | |
| 52.29178467 | 1 | |
| 52.29220885 | 1 | |
| 52.29277879 | 1 | |
| 52.29281904 | 1 |
| Value | Count | Frequency (%) |
| 52.42471256 | 1 | |
| 52.42464056 | 1 | |
| 52.42399339 | 1 | |
| 52.42380134 | 1 | |
| 52.42364739 | 1 | |
| 52.42350166 | 1 | |
| 52.4234977 | 1 | |
| 52.42343234 | 1 | |
| 52.42336689 | 1 | |
| 52.42332129 | 1 |
longitude
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 20030 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.8889774 |
| Minimum | 4.7532466 |
|---|---|
| Maximum | 5.027689 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 156.6 KiB |
Quantile statistics
| Minimum | 4.7532466 |
|---|---|
| 5-th percentile | 4.8445341 |
| Q1 | 4.8635951 |
| median | 4.8863869 |
| Q3 | 4.9082884 |
| 95-th percentile | 4.9460886 |
| Maximum | 5.027689 |
| Range | 0.27444239 |
| Interquartile range (IQR) | 0.044693385 |
Descriptive statistics
| Standard deviation | 0.035573429 |
|---|---|
| Coefficient of variation (CV) | 0.0072762515 |
| Kurtosis | 1.1442911 |
| Mean | 4.8889774 |
| Median Absolute Deviation (MAD) | 0.022407105 |
| Skewness | 0.55247624 |
| Sum | 97926.216 |
| Variance | 0.0012654688 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.941419235 | 1 | < 0.1% |
| 4.926475131 | 1 | < 0.1% |
| 4.925121865 | 1 | < 0.1% |
| 4.859313343 | 1 | < 0.1% |
| 4.923211504 | 1 | < 0.1% |
| 4.883201766 | 1 | < 0.1% |
| 4.894525181 | 1 | < 0.1% |
| 4.92743154 | 1 | < 0.1% |
| 4.920524682 | 1 | < 0.1% |
| 4.93293638 | 1 | < 0.1% |
| Other values (20020) | 20020 |
| Value | Count | Frequency (%) |
| 4.753246567 | 1 | |
| 4.759434181 | 1 | |
| 4.763264201 | 1 | |
| 4.765050687 | 1 | |
| 4.768451848 | 1 | |
| 4.772158795 | 1 | |
| 4.773175277 | 1 | |
| 4.775167687 | 1 | |
| 4.775504535 | 1 | |
| 4.775947779 | 1 |
| Value | Count | Frequency (%) |
| 5.027688954 | 1 | |
| 5.026700926 | 1 | |
| 5.018401449 | 1 | |
| 5.018302533 | 1 | |
| 5.018060461 | 1 | |
| 5.017531443 | 1 | |
| 5.016975529 | 1 | |
| 5.013616381 | 1 | |
| 5.01355728 | 1 | |
| 5.013534319 | 1 |
room_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.6 KiB |
| Entire home/apt | |
|---|---|
| Private room | |
| Shared room | 65 |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 14.376535 |
| Min length | 11 |
Characters and Unicode
| Total characters | 287962 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Private room |
|---|---|
| 2nd row | Entire home/apt |
| 3rd row | Entire home/apt |
| 4th row | Entire home/apt |
| 5th row | Private room |
Common Values
| Value | Count | Frequency (%) |
| Entire home/apt | 15889 | |
| Private room | 4076 | 20.3% |
| Shared room | 65 | 0.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| entire | 15889 | |
| home/apt | 15889 | |
| room | 4141 | 10.3% |
| private | 4076 | 10.2% |
| shared | 65 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 35919 | |
| t | 35854 | |
| o | 24171 | |
| r | 24171 | |
| a | 20030 | 7.0% |
| 20030 | 7.0% | |
| m | 20030 | 7.0% |
| i | 19965 | 6.9% |
| h | 15954 | 5.5% |
| p | 15889 | 5.5% |
| Other values (7) | 55949 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 232013 | |
| Space Separator | 20030 | 7.0% |
| Uppercase Letter | 20030 | 7.0% |
| Other Punctuation | 15889 | 5.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 35919 | |
| t | 35854 | |
| o | 24171 | |
| r | 24171 | |
| a | 20030 | |
| m | 20030 | |
| i | 19965 | |
| h | 15954 | |
| p | 15889 | |
| n | 15889 | |
| Other values (2) | 4141 | 1.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 15889 | |
| P | 4076 | 20.3% |
| S | 65 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 20030 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 15889 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 252043 | |
| Common | 35919 | 12.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 35919 | |
| t | 35854 | |
| o | 24171 | |
| r | 24171 | |
| a | 20030 | |
| m | 20030 | |
| i | 19965 | |
| h | 15954 | |
| p | 15889 | |
| E | 15889 | |
| Other values (5) | 24171 |
Common
| Value | Count | Frequency (%) |
| 20030 | ||
| / | 15889 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 287962 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 35919 | |
| t | 35854 | |
| o | 24171 | |
| r | 24171 | |
| a | 20030 | 7.0% |
| 20030 | 7.0% | |
| m | 20030 | 7.0% |
| i | 19965 | 6.9% |
| h | 15954 | 5.5% |
| p | 15889 | 5.5% |
| Other values (7) | 55949 |
price
Real number (ℝ)
| Distinct | 429 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 152.18118 |
| Minimum | 0 |
|---|---|
| Maximum | 8500 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 156.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 60 |
| Q1 | 96 |
| median | 125 |
| Q3 | 175 |
| 95-th percentile | 300 |
| Maximum | 8500 |
| Range | 8500 |
| Interquartile range (IQR) | 79 |
Descriptive statistics
| Standard deviation | 145.82898 |
|---|---|
| Coefficient of variation (CV) | 0.95825895 |
| Kurtosis | 1168.155 |
| Mean | 152.18118 |
| Median Absolute Deviation (MAD) | 35 |
| Skewness | 25.447702 |
| Sum | 3048189 |
| Variance | 21266.09 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 150 | 1209 | 6.0% |
| 100 | 1117 | 5.6% |
| 120 | 961 | 4.8% |
| 200 | 667 | 3.3% |
| 125 | 656 | 3.3% |
| 110 | 563 | 2.8% |
| 175 | 540 | 2.7% |
| 90 | 531 | 2.7% |
| 80 | 527 | 2.6% |
| 130 | 525 | 2.6% |
| Other values (419) | 12734 |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 23 | 2 | < 0.1% |
| 24 | 1 | < 0.1% |
| 25 | 6 | |
| 26 | 4 |
| Value | Count | Frequency (%) |
| 8500 | 1 | |
| 8000 | 1 | |
| 5040 | 1 | |
| 5000 | 1 | |
| 4500 | 1 | |
| 3900 | 1 | |
| 3142 | 1 | |
| 3000 | 1 | |
| 2500 | 2 | |
| 2200 | 1 |
minimum_nights
Real number (ℝ)
| Distinct | 51 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.3287069 |
| Minimum | 1 |
|---|---|
| Maximum | 1001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 156.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 7 |
| Maximum | 1001 |
| Range | 1000 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 12.537419 |
|---|---|
| Coefficient of variation (CV) | 3.7664532 |
| Kurtosis | 4130.872 |
| Mean | 3.3287069 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 56.361392 |
| Sum | 66674 |
| Variance | 157.18687 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 8104 | |
| 3 | 4965 | |
| 1 | 3128 | 15.6% |
| 4 | 1555 | 7.8% |
| 5 | 982 | 4.9% |
| 7 | 555 | 2.8% |
| 6 | 243 | 1.2% |
| 14 | 90 | 0.4% |
| 10 | 82 | 0.4% |
| 30 | 61 | 0.3% |
| Other values (41) | 265 | 1.3% |
| Value | Count | Frequency (%) |
| 1 | 3128 | 15.6% |
| 2 | 8104 | |
| 3 | 4965 | |
| 4 | 1555 | 7.8% |
| 5 | 982 | 4.9% |
| 6 | 243 | 1.2% |
| 7 | 555 | 2.8% |
| 8 | 30 | 0.1% |
| 9 | 17 | 0.1% |
| 10 | 82 | 0.4% |
| Value | Count | Frequency (%) |
| 1001 | 1 | < 0.1% |
| 999 | 1 | < 0.1% |
| 365 | 3 | |
| 300 | 1 | < 0.1% |
| 230 | 1 | < 0.1% |
| 222 | 1 | < 0.1% |
| 186 | 1 | < 0.1% |
| 185 | 1 | < 0.1% |
| 183 | 1 | < 0.1% |
| 181 | 1 | < 0.1% |
number_of_reviews
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 354 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.560459 |
| Minimum | 0 |
|---|---|
| Maximum | 695 |
| Zeros | 2388 |
| Zeros (%) | 11.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 156.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| median | 8 |
| Q3 | 22 |
| 95-th percentile | 85 |
| Maximum | 695 |
| Range | 695 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 43.240292 |
|---|---|
| Coefficient of variation (CV) | 2.0055367 |
| Kurtosis | 41.501917 |
| Mean | 21.560459 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 5.4150261 |
| Sum | 431856 |
| Variance | 1869.7228 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2388 | 11.9% |
| 1 | 1408 | 7.0% |
| 2 | 1198 | 6.0% |
| 3 | 1071 | 5.3% |
| 4 | 956 | 4.8% |
| 5 | 857 | 4.3% |
| 6 | 779 | 3.9% |
| 7 | 725 | 3.6% |
| 8 | 651 | 3.3% |
| 9 | 586 | 2.9% |
| Other values (344) | 9411 |
| Value | Count | Frequency (%) |
| 0 | 2388 | |
| 1 | 1408 | |
| 2 | 1198 | |
| 3 | 1071 | |
| 4 | 956 | |
| 5 | 857 | 4.3% |
| 6 | 779 | 3.9% |
| 7 | 725 | 3.6% |
| 8 | 651 | 3.3% |
| 9 | 586 | 2.9% |
| Value | Count | Frequency (%) |
| 695 | 1 | |
| 631 | 1 | |
| 606 | 1 | |
| 602 | 1 | |
| 580 | 1 | |
| 576 | 1 | |
| 574 | 1 | |
| 541 | 1 | |
| 540 | 1 | |
| 527 | 1 |
last_review
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 1202 |
|---|---|
| Distinct (%) | 6.8% |
| Missing | 2406 |
| Missing (%) | 12.0% |
| Memory size | 156.6 KiB |
| 2018-12-02 | 492 |
|---|---|
| 2018-11-18 | 472 |
| 2018-11-25 | 457 |
| 2018-10-21 | 350 |
| 2018-11-04 | 345 |
| Other values (1197) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 176240 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 264 ? |
|---|---|
| Unique (%) | 1.5% |
Sample
| 1st row | 2018-11-28 |
|---|---|
| 2nd row | 2018-08-29 |
| 3rd row | 2018-11-30 |
| 4th row | 2018-01-21 |
| 5th row | 2018-11-25 |
Common Values
| Value | Count | Frequency (%) |
| 2018-12-02 | 492 | 2.5% |
| 2018-11-18 | 472 | 2.4% |
| 2018-11-25 | 457 | 2.3% |
| 2018-10-21 | 350 | 1.7% |
| 2018-11-04 | 345 | 1.7% |
| 2018-10-22 | 279 | 1.4% |
| 2018-12-03 | 270 | 1.3% |
| 2018-11-19 | 235 | 1.2% |
| 2018-11-11 | 230 | 1.1% |
| 2018-10-28 | 221 | 1.1% |
| Other values (1192) | 14273 | |
| (Missing) | 2406 | 12.0% |
Length
| Value | Count | Frequency (%) |
| 2018-12-02 | 492 | 2.8% |
| 2018-11-18 | 472 | 2.7% |
| 2018-11-25 | 457 | 2.6% |
| 2018-10-21 | 350 | 2.0% |
| 2018-11-04 | 345 | 2.0% |
| 2018-10-22 | 279 | 1.6% |
| 2018-12-03 | 270 | 1.5% |
| 2018-11-19 | 235 | 1.3% |
| 2018-11-11 | 230 | 1.3% |
| 2018-10-28 | 221 | 1.3% |
| Other values (1192) | 14273 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 37787 | |
| 0 | 36612 | |
| - | 35248 | |
| 2 | 27701 | |
| 8 | 17594 | |
| 7 | 5646 | 3.2% |
| 6 | 3669 | 2.1% |
| 9 | 3625 | 2.1% |
| 5 | 3088 | 1.8% |
| 3 | 2843 | 1.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 140992 | |
| Dash Punctuation | 35248 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 37787 | |
| 0 | 36612 | |
| 2 | 27701 | |
| 8 | 17594 | |
| 7 | 5646 | 4.0% |
| 6 | 3669 | 2.6% |
| 9 | 3625 | 2.6% |
| 5 | 3088 | 2.2% |
| 3 | 2843 | 2.0% |
| 4 | 2427 | 1.7% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 35248 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 176240 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 37787 | |
| 0 | 36612 | |
| - | 35248 | |
| 2 | 27701 | |
| 8 | 17594 | |
| 7 | 5646 | 3.2% |
| 6 | 3669 | 2.1% |
| 9 | 3625 | 2.1% |
| 5 | 3088 | 1.8% |
| 3 | 2843 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 176240 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 37787 | |
| 0 | 36612 | |
| - | 35248 | |
| 2 | 27701 | |
| 8 | 17594 | |
| 7 | 5646 | 3.2% |
| 6 | 3669 | 2.1% |
| 9 | 3625 | 2.1% |
| 5 | 3088 | 1.8% |
| 3 | 2843 | 1.6% |
reviews_per_month
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 754 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 2406 |
| Missing (%) | 12.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0620801 |
| Minimum | 0.01 |
|---|---|
| Maximum | 11.85 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 156.6 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.07 |
| Q1 | 0.27 |
| median | 0.62 |
| Q3 | 1.23 |
| 95-th percentile | 4 |
| Maximum | 11.85 |
| Range | 11.84 |
| Interquartile range (IQR) | 0.96 |
Descriptive statistics
| Standard deviation | 1.3333201 |
|---|---|
| Coefficient of variation (CV) | 1.2553856 |
| Kurtosis | 9.2001935 |
| Mean | 1.0620801 |
| Median Absolute Deviation (MAD) | 0.41 |
| Skewness | 2.7343685 |
| Sum | 18718.1 |
| Variance | 1.7777425 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.03 | 239 | 1.2% |
| 0.07 | 238 | 1.2% |
| 1 | 236 | 1.2% |
| 0.25 | 211 | 1.1% |
| 0.06 | 208 | 1.0% |
| 0.18 | 205 | 1.0% |
| 0.27 | 199 | 1.0% |
| 0.17 | 193 | 1.0% |
| 0.1 | 192 | 1.0% |
| 0.2 | 181 | 0.9% |
| Other values (744) | 15522 | |
| (Missing) | 2406 | 12.0% |
| Value | Count | Frequency (%) |
| 0.01 | 5 | < 0.1% |
| 0.02 | 75 | 0.4% |
| 0.03 | 239 | |
| 0.04 | 163 | |
| 0.05 | 153 | |
| 0.06 | 208 | |
| 0.07 | 238 | |
| 0.08 | 145 | |
| 0.09 | 157 | |
| 0.1 | 192 |
| Value | Count | Frequency (%) |
| 11.85 | 1 | |
| 11.58 | 1 | |
| 11.44 | 1 | |
| 11.09 | 1 | |
| 10.96 | 1 | |
| 10.86 | 1 | |
| 10.68 | 1 | |
| 10.15 | 1 | |
| 10.12 | 1 | |
| 10.01 | 1 |
calculated_host_listings_count
Real number (ℝ)
| Distinct | 27 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.734698 |
| Minimum | 1 |
|---|---|
| Maximum | 208 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 156.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 6 |
| Maximum | 208 |
| Range | 207 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 22.921886 |
|---|---|
| Coefficient of variation (CV) | 4.8412563 |
| Kurtosis | 63.73466 |
| Mean | 4.734698 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.8549484 |
| Sum | 94836 |
| Variance | 525.41286 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 15830 | |
| 2 | 2208 | 11.0% |
| 3 | 522 | 2.6% |
| 208 | 208 | 1.0% |
| 4 | 200 | 1.0% |
| 5 | 185 | 0.9% |
| 6 | 144 | 0.7% |
| 105 | 105 | 0.5% |
| 83 | 83 | 0.4% |
| 7 | 63 | 0.3% |
| Other values (17) | 482 | 2.4% |
| Value | Count | Frequency (%) |
| 1 | 15830 | |
| 2 | 2208 | 11.0% |
| 3 | 522 | 2.6% |
| 4 | 200 | 1.0% |
| 5 | 185 | 0.9% |
| 6 | 144 | 0.7% |
| 7 | 63 | 0.3% |
| 8 | 48 | 0.2% |
| 9 | 36 | 0.2% |
| 10 | 30 | 0.1% |
| Value | Count | Frequency (%) |
| 208 | 208 | |
| 105 | 105 | |
| 83 | 83 | 0.4% |
| 38 | 38 | 0.2% |
| 30 | 30 | 0.1% |
| 27 | 27 | 0.1% |
| 25 | 25 | 0.1% |
| 24 | 24 | 0.1% |
| 21 | 42 | 0.2% |
| 19 | 38 | 0.2% |
availability_365
Real number (ℝ)
| Distinct | 366 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59.913679 |
| Minimum | 0 |
|---|---|
| Maximum | 365 |
| Zeros | 9344 |
| Zeros (%) | 46.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 156.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3 |
| Q3 | 67 |
| 95-th percentile | 336 |
| Maximum | 365 |
| Range | 365 |
| Interquartile range (IQR) | 67 |
Descriptive statistics
| Standard deviation | 104.02771 |
|---|---|
| Coefficient of variation (CV) | 1.7362931 |
| Kurtosis | 1.9994437 |
| Mean | 59.913679 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.8194251 |
| Sum | 1200071 |
| Variance | 10821.765 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9344 | |
| 5 | 245 | 1.2% |
| 3 | 244 | 1.2% |
| 4 | 241 | 1.2% |
| 7 | 239 | 1.2% |
| 2 | 235 | 1.2% |
| 6 | 228 | 1.1% |
| 1 | 225 | 1.1% |
| 8 | 213 | 1.1% |
| 9 | 196 | 1.0% |
| Other values (356) | 8620 |
| Value | Count | Frequency (%) |
| 0 | 9344 | |
| 1 | 225 | 1.1% |
| 2 | 235 | 1.2% |
| 3 | 244 | 1.2% |
| 4 | 241 | 1.2% |
| 5 | 245 | 1.2% |
| 6 | 228 | 1.1% |
| 7 | 239 | 1.2% |
| 8 | 213 | 1.1% |
| 9 | 196 | 1.0% |
| Value | Count | Frequency (%) |
| 365 | 66 | |
| 364 | 162 | |
| 363 | 46 | 0.2% |
| 362 | 44 | 0.2% |
| 361 | 39 | 0.2% |
| 360 | 28 | 0.1% |
| 359 | 30 | 0.1% |
| 358 | 42 | 0.2% |
| 357 | 40 | 0.2% |
| 356 | 28 | 0.1% |
| id | host_id | latitude | longitude | price | minimum_nights | number_of_reviews | reviews_per_month | calculated_host_listings_count | availability_365 | neighbourhood | room_type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | 1.000 | 0.463 | -0.010 | 0.004 | 0.026 | -0.120 | -0.453 | 0.269 | 0.125 | 0.067 | 0.039 | 0.054 |
| host_id | 0.463 | 1.000 | -0.018 | 0.036 | -0.023 | -0.139 | -0.200 | 0.123 | 0.028 | -0.005 | 0.055 | 0.061 |
| latitude | -0.010 | -0.018 | 1.000 | -0.127 | 0.000 | 0.002 | 0.067 | 0.062 | 0.038 | 0.027 | 0.679 | 0.079 |
| longitude | 0.004 | 0.036 | -0.127 | 1.000 | 0.047 | 0.017 | 0.005 | 0.016 | 0.011 | 0.027 | 0.664 | 0.095 |
| price | 0.026 | -0.023 | 0.000 | 0.047 | 1.000 | 0.116 | -0.065 | -0.054 | -0.032 | 0.149 | 0.007 | 0.000 |
| minimum_nights | -0.120 | -0.139 | 0.002 | 0.017 | 0.116 | 1.000 | -0.080 | -0.206 | -0.079 | -0.003 | 0.006 | 0.000 |
| number_of_reviews | -0.453 | -0.200 | 0.067 | 0.005 | -0.065 | -0.080 | 1.000 | 0.650 | 0.013 | 0.260 | 0.033 | 0.226 |
| reviews_per_month | 0.269 | 0.123 | 0.062 | 0.016 | -0.054 | -0.206 | 0.650 | 1.000 | 0.160 | 0.421 | 0.064 | 0.316 |
| calculated_host_listings_count | 0.125 | 0.028 | 0.038 | 0.011 | -0.032 | -0.079 | 0.013 | 0.160 | 1.000 | 0.204 | 0.042 | 0.053 |
| availability_365 | 0.067 | -0.005 | 0.027 | 0.027 | 0.149 | -0.003 | 0.260 | 0.421 | 0.204 | 1.000 | 0.067 | 0.167 |
| neighbourhood | 0.039 | 0.055 | 0.679 | 0.664 | 0.007 | 0.006 | 0.033 | 0.064 | 0.042 | 0.067 | 1.000 | 0.139 |
| room_type | 0.054 | 0.061 | 0.079 | 0.095 | 0.000 | 0.000 | 0.226 | 0.316 | 0.053 | 0.167 | 0.139 | 1.000 |
| id | name | host_id | host_name | neighbourhood_group | neighbourhood | latitude | longitude | room_type | price | minimum_nights | number_of_reviews | last_review | reviews_per_month | calculated_host_listings_count | availability_365 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2818 | Quiet Garden View Room & Super Fast WiFi | 3159 | Daniel | NaN | Oostelijk Havengebied - Indische Buurt | 52.365755 | 4.941419 | Private room | 59 | 3 | 248 | 2018-11-28 | 2.10 | 1 | 44 |
| 1 | 3209 | Quiet apt near center, great view | 3806 | Maartje | NaN | Westerpark | 52.390225 | 4.873924 | Entire home/apt | 160 | 4 | 42 | 2018-08-29 | 1.03 | 1 | 47 |
| 2 | 20168 | 100%Centre-Studio 1 Private Floor/Bathroom | 59484 | Alex | NaN | Centrum-Oost | 52.365087 | 4.893541 | Entire home/apt | 80 | 1 | 233 | 2018-11-30 | 2.18 | 2 | 198 |
| 3 | 25428 | Lovely apt in City Centre (Jordaan) | 56142 | Joan | NaN | Centrum-West | 52.373114 | 4.883668 | Entire home/apt | 125 | 14 | 1 | 2018-01-21 | 0.09 | 2 | 141 |
| 4 | 27886 | Romantic, stylish B&B houseboat in canal district | 97647 | Flip | NaN | Centrum-West | 52.386727 | 4.892078 | Private room | 150 | 2 | 171 | 2018-11-25 | 2.03 | 1 | 199 |
| 5 | 28658 | Cosy guest room near city centre -1 | 123414 | Michele | NaN | Bos en Lommer | 52.375342 | 4.857289 | Private room | 65 | 3 | 434 | 2018-11-19 | 4.16 | 2 | 295 |
| 6 | 28871 | Comfortable double room | 124245 | Edwin | NaN | Centrum-West | 52.367187 | 4.890918 | Private room | 75 | 2 | 215 | 2018-12-03 | 2.13 | 3 | 137 |
| 7 | 29051 | Comfortable single room | 124245 | Edwin | NaN | Centrum-West | 52.367725 | 4.891512 | Private room | 55 | 2 | 383 | 2018-12-05 | 4.07 | 3 | 188 |
| 8 | 31080 | 2-story apartment + rooftop terrace | 133488 | Nienke | NaN | Zuid | 52.351321 | 4.848383 | Entire home/apt | 219 | 3 | 32 | 2017-10-16 | 0.36 | 1 | 336 |
| 9 | 41125 | Amsterdam Center Entire Apartment | 178515 | Fatih | NaN | Centrum-West | 52.378915 | 4.883205 | Entire home/apt | 180 | 3 | 76 | 2018-10-07 | 0.78 | 1 | 11 |
| id | name | host_id | host_name | neighbourhood_group | neighbourhood | latitude | longitude | room_type | price | minimum_nights | number_of_reviews | last_review | reviews_per_month | calculated_host_listings_count | availability_365 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20020 | 30561688 | Cozy apartment close to the center of Amsterdam | 228892275 | Joel | NaN | Osdorp | 52.357365 | 4.784800 | Entire home/apt | 150 | 1 | 0 | NaN | NaN | 1 | 34 |
| 20021 | 30562273 | Designer & charming apartment in Oud-Zuid | 853028 | Elisa | NaN | Zuid | 52.351766 | 4.853029 | Entire home/apt | 150 | 2 | 0 | NaN | NaN | 1 | 23 |
| 20022 | 30562689 | Cosy two floor apartment with a big terrace | 229295710 | Mariana & Rob | NaN | Watergraafsmeer | 52.356327 | 4.933991 | Entire home/apt | 80 | 5 | 0 | NaN | NaN | 1 | 234 |
| 20023 | 30563877 | Large comfortable apartments in the center | 228749822 | Rozaliia | NaN | Centrum-Oost | 52.365812 | 4.896044 | Entire home/apt | 200 | 7 | 0 | NaN | NaN | 1 | 30 |
| 20024 | 30573892 | Clean and perfect location | 229361236 | Poppy | NaN | De Baarsjes - Oud-West | 52.363901 | 4.878162 | Entire home/apt | 81 | 1 | 0 | NaN | NaN | 1 | 133 |
| 20025 | 30576148 | Family House City + free Parking+garden (160 m2) | 13399651 | Marieke | NaN | Watergraafsmeer | 52.345999 | 4.952145 | Entire home/apt | 340 | 7 | 0 | NaN | NaN | 1 | 11 |
| 20026 | 30577727 | Home Sweet Home in Indische Buurt | 1595885 | Evita | NaN | Oostelijk Havengebied - Indische Buurt | 52.362412 | 4.932467 | Entire home/apt | 150 | 3 | 0 | NaN | NaN | 2 | 16 |
| 20027 | 30578037 | Amsterdam Cozy apartment nearby center | 87866499 | Tommaso | NaN | Oud-Oost | 52.362431 | 4.926912 | Entire home/apt | 80 | 10 | 0 | NaN | NaN | 2 | 210 |
| 20028 | 30579673 | Home Sweet Home for a Guest or a Couple | 1595885 | Evita | NaN | Oostelijk Havengebied - Indische Buurt | 52.363780 | 4.932493 | Private room | 55 | 2 | 0 | NaN | NaN | 2 | 31 |
| 20029 | 30580413 | Cosy two bedroom appartment near 'de Pijp'! | 27212057 | Lisa | NaN | De Pijp - Rivierenbuurt | 52.346911 | 4.901932 | Entire home/apt | 220 | 5 | 0 | NaN | NaN | 1 | 14 |